
IF ( OBJECT_ID('dbo.m_dictionaries_delete') IS NOT NULL ) 
   DROP PROCEDURE dbo.m_dictionaries_delete
GO

CREATE PROCEDURE [dbo].[m_dictionaries_delete] 
	@m_dictID int
AS
BEGIN

	SET NOCOUNT ON;

	DELETE FROM [dbo].[m_dictionaries]
	WHERE m_ID = @m_dictID
END
GO


--------------------------------------------------------

IF ( OBJECT_ID('dbo.m_languages_delete') IS NOT NULL ) 
   DROP PROCEDURE dbo.m_languages_delete
GO

CREATE PROCEDURE [dbo].[m_languages_delete] 
	@langID int
AS
BEGIN

	SET NOCOUNT ON;

	DELETE FROM [dbo].[m_languages]
	WHERE m_ID = @langID
END
GO


-------------------------------------------------------------------

IF ( OBJECT_ID('dbo.m_managerindict_delete') IS NOT NULL ) 
   DROP PROCEDURE dbo.m_managerindict_delete
GO

CREATE PROCEDURE [dbo].[m_managerindict_delete] 
	@m_userID int,
	@m_dictID int
AS
BEGIN

	SET NOCOUNT ON;

	DELETE FROM [dbo].[m_managerindict]
	WHERE m_userID = @m_userID	AND m_dictID = @m_dictID
END
GO

-------------------------------------------------



IF ( OBJECT_ID('dbo.m_users_delete') IS NOT NULL ) 
   DROP PROCEDURE dbo.m_users_delete
GO

CREATE PROCEDURE [dbo].[m_users_delete] 
	@m_userID int
AS
BEGIN

	SET NOCOUNT ON;

	DELETE FROM [dbo].[m_users]
	WHERE m_ID = @m_userID
END
GO

------------------------------------------------------

IF ( OBJECT_ID('dbo.m_approve_delete') IS NOT NULL ) 
   DROP PROCEDURE dbo.m_approve_delete
GO

CREATE PROCEDURE [dbo].[m_approve_delete] 
	@m_ID int
AS
BEGIN

	SET NOCOUNT ON;

	DELETE FROM [dbo].[m_approve]
	WHERE m_ID = @m_ID
END
GO